<?php
class Subcategorymanager_Data_Getcurrentsubcategory implements Subcategorymanager_Data_Mainable{
    
    private $core_controller_selectdata;
    
    public function __construct() {
        $this->core_controller_selectdata = new Core_Controller_Selectdata;
    }
    
    public function main(array $variables = null) {
        $variables['query'] = "SELECT subcategory_settings.subcategory_name, subcategory_settings.category_name, subcategory_settings.status_name, subcategory_settings.access_level, subcategory_meta_values.subcategory_meta_title, subcategory_meta_values.subcategory_meta_keywords, subcategory_meta_values.subcategory_meta_description, subcategory_content_values.subcategory_title, subcategory_content_values.subcategory_description, subcategory_content_values.subcategory_content, subcategory_content_values.image FROM subcategory_settings, subcategory_meta_values, subcategory_content_values WHERE subcategory_settings.subcategory_name = '".$variables['get']['name']."' AND subcategory_settings.subcategory_name = subcategory_content_values.subcategory_name AND subcategory_settings.subcategory_name = subcategory_meta_values.subcategory_name AND subcategory_content_values.subcategory_name = subcategory_meta_values.subcategory_name ORDER BY subcategory_content_values.subcategory_title ASC;";
        return $this->core_controller_selectdata->main($variables);
    }
}
